Preparing Data to be Imported

The files that you import data from must be in a specific format or else an error is reported and the import procedure fails. These files are called CSV files, and have the file extension .CSV.

CSV (comma separated value) files are a standard method of exchanging data between computer programs. The data must be in a text format, so if you type the data into a word processor or text editor, ensure that you save the file as a Text file. Many word processors provide a Save As option that can be used to convert files to a text format.